Dataset statistics
| Number of variables | 22 |
|---|---|
| Number of observations | 8708 |
| Missing cells | 29094 |
| Missing cells (%) | 15.2% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 1.5 MiB |
| Average record size in memory | 176.0 B |
Variable types
| CAT | 13 |
|---|---|
| NUM | 9 |
Reproduction
| Analysis started | 2020-08-14 06:13:02.038685 |
|---|---|
| Analysis finished | 2020-08-14 06:13:22.815775 |
| Duration | 20.78 seconds |
| Software version | pandas-profiling v2.9.0rc1 |
| Download configuration | config.yaml |
name has a high cardinality: 8574 distinct values | High cardinality |
neighbourhood has a high cardinality: 112 distinct values | High cardinality |
amenities has a high cardinality: 8045 distinct values | High cardinality |
price has a high cardinality: 465 distinct values | High cardinality |
weekly_price has a high cardinality: 254 distinct values | High cardinality |
monthly_price has a high cardinality: 240 distinct values | High cardinality |
security_deposit has a high cardinality: 92 distinct values | High cardinality |
cleaning_fee has a high cardinality: 167 distinct values | High cardinality |
extra_people has a high cardinality: 64 distinct values | High cardinality |
square_feet has 8671 (99.6%) missing values | Missing |
weekly_price has 7854 (90.2%) missing values | Missing |
monthly_price has 7972 (91.5%) missing values | Missing |
security_deposit has 2845 (32.7%) missing values | Missing |
cleaning_fee has 1632 (18.7%) missing values | Missing |
bathrooms is highly skewed (γ1 = 20.8395) | Skewed |
maximum_nights is highly skewed (γ1 = 93.0233) | Skewed |
name is uniformly distributed | Uniform |
amenities is uniformly distributed | Uniform |
id has unique values | Unique |
bedrooms has 841 (9.7%) zeros | Zeros |
beds has 249 (2.9%) zeros | Zeros |
| Distinct count | 8708 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.24806e+07 |
|---|---|
| Minimum | 3663 |
| Maximum | 4.3835e+07 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 68.0 KiB |
Quantile statistics
| Minimum | 3663 |
|---|---|
| 5-th percentile | 2.66113e+06 |
| Q1 | 1.35745e+07 |
| median | 2.06516e+07 |
| Q3 | 3.37451e+07 |
| 95-th percentile | 4.25411e+07 |
| Maximum | 4.3835e+07 |
| Range | 4.38313e+07 |
| Interquartile range (IQR) | 2.01707e+07 |
Descriptive statistics
| Standard deviation | 1.24425e+07 |
|---|---|
| Coefficient of variation (CV) | 0.553479 |
| Kurtosis | -1.0909 |
| Mean | 2.24806e+07 |
| Median Absolute Deviation (MAD) | 1.00897e+07 |
| Skewness | 0.108562 |
| Sum | 1.95761e+11 |
| Variance | 1.54817e+14 |
| Monotocity | Strictly increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 1.61239e+07 | 1 | < 0.1% | |
| 2.80117e+07 | 1 | < 0.1% | |
| 4.35693e+07 | 1 | < 0.1% | |
| 1.35016e+07 | 1 | < 0.1% | |
| 2.19324e+07 | 1 | < 0.1% | |
| 355527 | 1 | < 0.1% | |
| 2.20008e+07 | 1 | < 0.1% | |
| 722114 | 1 | < 0.1% | |
| 3.39475e+06 | 1 | < 0.1% | |
| 2.85449e+07 | 1 | < 0.1% | |
| Other values (8698) | 8698 | 99.9% |
| Value | Count | Frequency (%) | |
| 3663 | 1 | < 0.1% | |
| 3670 | 1 | < 0.1% | |
| 3686 | 1 | < 0.1% | |
| 3771 | 1 | < 0.1% | |
| 3943 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 4.3835e+07 | 1 | < 0.1% | |
| 4.38346e+07 | 1 | < 0.1% | |
| 4.38345e+07 | 1 | < 0.1% | |
| 4.382e+07 | 1 | < 0.1% | |
| 4.38197e+07 | 1 | < 0.1% |
| Distinct count | 8574 |
|---|---|
| Unique (%) | 98.5% |
| Missing | 2 |
| Missing (%) | < 0.1% |
| Memory size | 68.0 KiB |
| NW DC 30 Day Stays One Bedroom | 10 |
|---|---|
| Spacious Queen Room in Columbia Heights | 9 |
| Spacious Queen Room in Shaw | 8 |
| Sojourn the 13th Street Flats | 6 |
| Very Comfy & Cute Luxe Twin Bed in Shared Room 1 | 5 |
| Other values (8569) |
| Value | Count | Frequency (%) | |
| NW DC 30 Day Stays One Bedroom | 10 | 0.1% | |
| Spacious Queen Room in Columbia Heights | 9 | 0.1% | |
| Spacious Queen Room in Shaw | 8 | 0.1% | |
| Sojourn the 13th Street Flats | 6 | 0.1% | |
| Very Comfy & Cute Luxe Twin Bed in Shared Room 1 | 5 | 0.1% | |
| Shaw Convention Center Apartments 30 Day Stays Two Bedroom | 5 | 0.1% | |
| Spacious Queen Room in Capitol Hill | 5 | 0.1% | |
| Walter Convention Center Apartments 30 Day Stays Two Bedroom | 5 | 0.1% | |
| Lux 1 Bedroom near White House w/wifi | 4 | < 0.1% | |
| Sojourn Boutique at Dupont Place | 4 | < 0.1% | |
| Other values (8564) | 8645 | 99.3% |
Length
| Max length | 98 |
|---|---|
| Median length | 42 |
| Mean length | 39.6918 |
| Min length | 1 |
| Distinct count | 112 |
|---|---|
| Unique (%) | 1.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 68.0 KiB |
| Capitol Hill | |
|---|---|
| Dupont Circle | 488 |
| Columbia Heights | 432 |
| Near Northeast/H Street Corridor | 393 |
| Logan Circle | 388 |
| Other values (107) |
| Value | Count | Frequency (%) | |
| Capitol Hill | 1020 | 11.7% | |
| Dupont Circle | 488 | 5.6% | |
| Columbia Heights | 432 | 5.0% | |
| Near Northeast/H Street Corridor | 393 | 4.5% | |
| Logan Circle | 388 | 4.5% | |
| Shaw | 375 | 4.3% | |
| U Street Corridor | 340 | 3.9% | |
| Petworth | 297 | 3.4% | |
| Adams Morgan | 265 | 3.0% | |
| Foggy Bottom | 224 | 2.6% | |
| Other values (102) | 4486 | 51.5% |
Length
| Max length | 35 |
|---|---|
| Median length | 12 |
| Mean length | 13.1548 |
| Min length | 4 |
neighbourhood_cleansed
Categorical
| Distinct count | 39 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 68.0 KiB |
| Union Station, Stanton Park, Kingman Park | |
|---|---|
| Columbia Heights, Mt. Pleasant, Pleasant Plains, Park View | |
| Capitol Hill, Lincoln Park | |
| Dupont Circle, Connecticut Avenue/K Street | |
| Edgewood, Bloomingdale, Truxton Circle, Eckington | |
| Other values (34) |
| Value | Count | Frequency (%) | |
| Union Station, Stanton Park, Kingman Park | 835 | 9.6% | |
| Columbia Heights, Mt. Pleasant, Pleasant Plains, Park View | 821 | 9.4% | |
| Capitol Hill, Lincoln Park | 808 | 9.3% | |
| Dupont Circle, Connecticut Avenue/K Street | 679 | 7.8% | |
| Edgewood, Bloomingdale, Truxton Circle, Eckington | 636 | 7.3% | |
| Shaw, Logan Circle | 597 | 6.9% | |
| Brightwood Park, Crestwood, Petworth | 485 | 5.6% | |
| Kalorama Heights, Adams Morgan, Lanier Heights | 400 | 4.6% | |
| Downtown, Chinatown, Penn Quarters, Mount Vernon Square, North Capitol Street | 381 | 4.4% | |
| Howard University, Le Droit Park, Cardozo/Shaw | 336 | 3.9% | |
| Other values (29) | 2730 | 31.4% |
Length
| Max length | 97 |
|---|---|
| Median length | 42 |
| Mean length | 43.613 |
| Min length | 18 |
zipcode
Categorical
| Distinct count | 49 |
|---|---|
| Unique (%) | 0.6% |
| Missing | 67 |
| Missing (%) | 0.8% |
| Memory size | 68.0 KiB |
| 20002 | |
|---|---|
| 20009 | |
| 20001 | |
| 20003 | |
| 20011 | |
| Other values (44) |
| Value | Count | Frequency (%) | |
| 20002 | 1468 | 16.9% | |
| 20009 | 1239 | 14.2% | |
| 20001 | 1142 | 13.1% | |
| 20003 | 763 | 8.8% | |
| 20011 | 649 | 7.5% | |
| 20010 | 516 | 5.9% | |
| 20007 | 390 | 4.5% | |
| 20005 | 303 | 3.5% | |
| 20019 | 259 | 3.0% | |
| 20020 | 244 | 2.8% | |
| Other values (39) | 1668 | 19.2% |
Length
| Max length | 10 |
|---|---|
| Median length | 5 |
| Mean length | 5.02871 |
| Min length | 1 |
property_type
Categorical
| Distinct count | 22 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 68.0 KiB |
| Apartment | |
|---|---|
| House | |
| Townhouse | |
| Condominium | |
| Guest suite | |
| Other values (17) |
| Value | Count | Frequency (%) | |
| Apartment | 3767 | 43.3% | |
| House | 1793 | 20.6% | |
| Townhouse | 1300 | 14.9% | |
| Condominium | 739 | 8.5% | |
| Guest suite | 503 | 5.8% | |
| Serviced apartment | 310 | 3.6% | |
| Boutique hotel | 59 | 0.7% | |
| Guesthouse | 55 | 0.6% | |
| Loft | 54 | 0.6% | |
| Bed and breakfast | 37 | 0.4% | |
| Other values (12) | 91 | 1.0% |
Length
| Max length | 18 |
|---|---|
| Median length | 9 |
| Mean length | 8.79536 |
| Min length | 4 |
room_type
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 68.0 KiB |
| Entire home/apt | |
|---|---|
| Private room | |
| Shared room | 199 |
| Hotel room | 44 |
| Value | Count | Frequency (%) | |
| Entire home/apt | 6159 | 70.7% | |
| Private room | 2306 | 26.5% | |
| Shared room | 199 | 2.3% | |
| Hotel room | 44 | 0.5% |
Length
| Max length | 15 |
|---|---|
| Median length | 15 |
| Mean length | 14.0889 |
| Min length | 10 |
accommodates
Real number (ℝ≥0)
| Distinct count | 16 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.60622 |
|---|---|
| Minimum | 1 |
| Maximum | 16 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 68.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 8 |
| Maximum | 16 |
| Range | 15 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 2.35845 |
|---|---|
| Coefficient of variation (CV) | 0.653994 |
| Kurtosis | 5.93212 |
| Mean | 3.60622 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.99351 |
| Sum | 31403 |
| Variance | 5.56228 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=16)
| Value | Count | Frequency (%) | |
| 2 | 3085 | 35.4% | |
| 4 | 1885 | 21.6% | |
| 3 | 952 | 10.9% | |
| 6 | 819 | 9.4% | |
| 1 | 769 | 8.8% | |
| 5 | 479 | 5.5% | |
| 8 | 306 | 3.5% | |
| 7 | 121 | 1.4% | |
| 10 | 93 | 1.1% | |
| 12 | 56 | 0.6% | |
| Other values (6) | 143 | 1.6% |
| Value | Count | Frequency (%) | |
| 1 | 769 | 8.8% | |
| 2 | 3085 | 35.4% | |
| 3 | 952 | 10.9% | |
| 4 | 1885 | 21.6% | |
| 5 | 479 | 5.5% |
| Value | Count | Frequency (%) | |
| 16 | 53 | 0.6% | |
| 15 | 9 | 0.1% | |
| 14 | 18 | 0.2% | |
| 13 | 10 | 0.1% | |
| 12 | 56 | 0.6% |
| Distinct count | 21 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 8 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.35494 |
|---|---|
| Minimum | 0 |
| Maximum | 50 |
| Zeros | 17 |
| Zeros (%) | 0.2% |
| Memory size | 68.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1.5 |
| 95-th percentile | 2.5 |
| Maximum | 50 |
| Range | 50 |
| Interquartile range (IQR) | 0.5 |
Descriptive statistics
| Standard deviation | 0.887767 |
|---|---|
| Coefficient of variation (CV) | 0.655206 |
| Kurtosis | 1046.44 |
| Mean | 1.35494 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 20.8395 |
| Sum | 11788 |
| Variance | 0.788129 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=21)
| Value | Count | Frequency (%) | |
| 1 | 6144 | 70.6% | |
| 2 | 922 | 10.6% | |
| 1.5 | 733 | 8.4% | |
| 2.5 | 502 | 5.8% | |
| 3.5 | 149 | 1.7% | |
| 3 | 133 | 1.5% | |
| 4.5 | 32 | 0.4% | |
| 4 | 31 | 0.4% | |
| 0 | 17 | 0.2% | |
| 0.5 | 7 | 0.1% | |
| Other values (11) | 30 | 0.3% | |
| (Missing) | 8 | 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 17 | 0.2% | |
| 0.5 | 7 | 0.1% | |
| 1 | 6144 | 70.6% | |
| 1.5 | 733 | 8.4% | |
| 2 | 922 | 10.6% |
| Value | Count | Frequency (%) | |
| 50 | 1 | < 0.1% | |
| 11 | 2 | < 0.1% | |
| 10.5 | 1 | < 0.1% | |
| 10 | 3 | < 0.1% | |
| 9 | 1 | < 0.1% |
| Distinct count | 13 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 8 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.36908 |
|---|---|
| Minimum | 0 |
| Maximum | 27 |
| Zeros | 841 |
| Zeros (%) | 9.7% |
| Memory size | 68.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 3 |
| Maximum | 27 |
| Range | 27 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.00521 |
|---|---|
| Coefficient of variation (CV) | 0.734223 |
| Kurtosis | 54.282 |
| Mean | 1.36908 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.59388 |
| Sum | 11911 |
| Variance | 1.01045 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=13)
| Value | Count | Frequency (%) | |
| 1 | 5271 | 60.5% | |
| 2 | 1627 | 18.7% | |
| 0 | 841 | 9.7% | |
| 3 | 650 | 7.5% | |
| 4 | 209 | 2.4% | |
| 5 | 66 | 0.8% | |
| 6 | 18 | 0.2% | |
| 7 | 9 | 0.1% | |
| 9 | 3 | < 0.1% | |
| 8 | 3 | < 0.1% | |
| Other values (3) | 3 | < 0.1% | |
| (Missing) | 8 | 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 841 | 9.7% | |
| 1 | 5271 | 60.5% | |
| 2 | 1627 | 18.7% | |
| 3 | 650 | 7.5% | |
| 4 | 209 | 2.4% |
| Value | Count | Frequency (%) | |
| 27 | 1 | < 0.1% | |
| 11 | 1 | < 0.1% | |
| 10 | 1 | < 0.1% | |
| 9 | 3 | < 0.1% | |
| 8 | 3 | < 0.1% |
| Distinct count | 21 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 35 |
| Missing (%) | 0.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.88724 |
|---|---|
| Minimum | 0 |
| Maximum | 51 |
| Zeros | 249 |
| Zeros (%) | 2.9% |
| Memory size | 68.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 4 |
| Maximum | 51 |
| Range | 51 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.6558 |
|---|---|
| Coefficient of variation (CV) | 0.877366 |
| Kurtosis | 183.064 |
| Mean | 1.88724 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 8.1993 |
| Sum | 16368 |
| Variance | 2.74166 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=21)
| Value | Count | Frequency (%) | |
| 1 | 4280 | 49.2% | |
| 2 | 2362 | 27.1% | |
| 3 | 946 | 10.9% | |
| 4 | 414 | 4.8% | |
| 0 | 249 | 2.9% | |
| 5 | 180 | 2.1% | |
| 6 | 111 | 1.3% | |
| 7 | 38 | 0.4% | |
| 8 | 34 | 0.4% | |
| 9 | 14 | 0.2% | |
| Other values (11) | 45 | 0.5% | |
| (Missing) | 35 | 0.4% |
| Value | Count | Frequency (%) | |
| 0 | 249 | 2.9% | |
| 1 | 4280 | 49.2% | |
| 2 | 2362 | 27.1% | |
| 3 | 946 | 10.9% | |
| 4 | 414 | 4.8% |
| Value | Count | Frequency (%) | |
| 51 | 1 | < 0.1% | |
| 50 | 1 | < 0.1% | |
| 19 | 1 | < 0.1% | |
| 18 | 1 | < 0.1% | |
| 17 | 1 | < 0.1% |
| Distinct count | 8045 |
|---|---|
| Unique (%) | 92.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 68.0 KiB |
| {TV,"Cable TV",Wifi,"Air conditioning",Kitchen,"Pets allowed",Gym,Elevator,Heating,Washer,Dryer,"Smoke alarm","Carbon monoxide alarm",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop-friendly workspace","Private entrance","Hot water","Bed linens","Extra pillows and blankets",Microwave,"Coffee maker",Refrigerator,Dishwasher,"Dishes and silverware","Cooking basics",Oven,Stove,"BBQ grill","Patio or balcony","Paid parking on premises"} | 45 |
|---|---|
| {TV,"Cable TV",Wifi,"Air conditioning",Pool,Kitchen,"Pets allowed",Gym,Heating,Washer,Dryer,"Smoke alarm","Carbon monoxide alarm",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop-friendly workspace","Private entrance","Hot water","Bed linens","Extra pillows and blankets","Ethernet connection",Microwave,"Coffee maker",Refrigerator,Dishwasher,"Dishes and silverware","Cooking basics",Oven,Stove} | 29 |
| {TV,"Cable TV",Wifi,"Air conditioning",Pool,Kitchen,"Pets allowed",Gym,Heating,Washer,Dryer,"Smoke alarm","Carbon monoxide alarm",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop-friendly workspace","Private entrance","Hot water","Bed linens","Extra pillows and blankets","Ethernet connection",Microwave,"Coffee maker",Refrigerator,Dishwasher,"Dishes and silverware","Cooking basics",Oven,Stove,"Shower gel","Trash can"} | 28 |
| {Wifi,"Air conditioning",Kitchen,Breakfast,Heating,"Smoke alarm","Carbon monoxide alarm","First aid kit","Fire extinguisher",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Self check-in",Keypad,"Room-darkening shades","Bed linens",Microwave,Refrigerator,"Dishes and silverware","Cooking basics",Oven,Stove,"Long term stays allowed"} | 19 |
| {TV,Wifi,"Air conditioning",Kitchen,Heating,Washer,Dryer,"Smoke alarm","Carbon monoxide alarm",Essentials,Shampoo,"Laptop-friendly workspace",Microwave,"Coffee maker",Refrigerator,Dishwasher,"Dishes and silverware","Cooking basics",Oven,Stove,"Long term stays allowed"} | 18 |
| Other values (8040) |
| Value | Count | Frequency (%) | |
| {TV,"Cable TV",Wifi,"Air conditioning",Kitchen,"Pets allowed",Gym,Elevator,Heating,Washer,Dryer,"Smoke alarm","Carbon monoxide alarm",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop-friendly workspace","Private entrance","Hot water","Bed linens","Extra pillows and blankets",Microwave,"Coffee maker",Refrigerator,Dishwasher,"Dishes and silverware","Cooking basics",Oven,Stove,"BBQ grill","Patio or balcony","Paid parking on premises"} | 45 | 0.5% | |
| {TV,"Cable TV",Wifi,"Air conditioning",Pool,Kitchen,"Pets allowed",Gym,Heating,Washer,Dryer,"Smoke alarm","Carbon monoxide alarm",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop-friendly workspace","Private entrance","Hot water","Bed linens","Extra pillows and blankets","Ethernet connection",Microwave,"Coffee maker",Refrigerator,Dishwasher,"Dishes and silverware","Cooking basics",Oven,Stove} | 29 | 0.3% | |
| {TV,"Cable TV",Wifi,"Air conditioning",Pool,Kitchen,"Pets allowed",Gym,Heating,Washer,Dryer,"Smoke alarm","Carbon monoxide alarm",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop-friendly workspace","Private entrance","Hot water","Bed linens","Extra pillows and blankets","Ethernet connection",Microwave,"Coffee maker",Refrigerator,Dishwasher,"Dishes and silverware","Cooking basics",Oven,Stove,"Shower gel","Trash can"} | 28 | 0.3% | |
| {Wifi,"Air conditioning",Kitchen,Breakfast,Heating,"Smoke alarm","Carbon monoxide alarm","First aid kit","Fire extinguisher",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Self check-in",Keypad,"Room-darkening shades","Bed linens",Microwave,Refrigerator,"Dishes and silverware","Cooking basics",Oven,Stove,"Long term stays allowed"} | 19 | 0.2% | |
| {TV,Wifi,"Air conditioning",Kitchen,Heating,Washer,Dryer,"Smoke alarm","Carbon monoxide alarm",Essentials,Shampoo,"Laptop-friendly workspace",Microwave,"Coffee maker",Refrigerator,Dishwasher,"Dishes and silverware","Cooking basics",Oven,Stove,"Long term stays allowed"} | 18 | 0.2% | |
| {TV,Wifi,Kitchen,"Pets allowed",Heating,Washer,Dryer,"Smoke alarm","Carbon monoxide alarm",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop-friendly workspace","Private entrance","Ethernet connection"} | 15 | 0.2% | |
| {} | 15 | 0.2% | |
| {TV,"Cable TV",Internet,Wifi,"Air conditioning",Kitchen,"Pets allowed",Gym,Elevator,Heating,"Family/kid friendly",Washer,Dryer,"Smoke alarm","Carbon monoxide alarm",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop-friendly workspace",Bathtub,"Hot water","Bed linens",Refrigerator,Oven,Stove,"Long term stays allowed"} | 13 | 0.1% | |
| {TV,"Cable TV",Wifi,"Air conditioning",Kitchen,"Pets allowed",Gym,Elevator,Heating,Washer,Dryer,"Smoke alarm","Carbon monoxide alarm",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Self check-in",Lockbox,"Private entrance","Bed linens",Microwave,"Coffee maker",Refrigerator,Dishwasher,Oven,"Patio or balcony","Long term stays allowed"} | 13 | 0.1% | |
| {Wifi,"Air conditioning",Kitchen,Breakfast,Heating,Washer,Dryer,"Smoke alarm","Carbon monoxide alarm","First aid kit","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door","Hair dryer",Iron} | 11 | 0.1% | |
| Other values (8035) | 8502 | 97.6% |
Length
| Max length | 1386 |
|---|---|
| Median length | 363 |
| Mean length | 377.223 |
| Min length | 2 |
| Distinct count | 25 |
|---|---|
| Unique (%) | 67.6% |
| Missing | 8671 |
| Missing (%) | 99.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1185.95 |
|---|---|
| Minimum | 0 |
| Maximum | 5300 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Memory size | 68.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 228 |
| Q1 | 575 |
| median | 1000 |
| Q3 | 1400 |
| 95-th percentile | 3200 |
| Maximum | 5300 |
| Range | 5300 |
| Interquartile range (IQR) | 825 |
Descriptive statistics
| Standard deviation | 1040 |
|---|---|
| Coefficient of variation (CV) | 0.876934 |
| Kurtosis | 7.066 |
| Mean | 1185.95 |
| Median Absolute Deviation (MAD) | 425 |
| Skewness | 2.43383 |
| Sum | 43880 |
| Variance | 1.08159e+06 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=25)
| Value | Count | Frequency (%) | |
| 1200 | 4 | < 0.1% | |
| 1000 | 3 | < 0.1% | |
| 500 | 3 | < 0.1% | |
| 1100 | 2 | < 0.1% | |
| 600 | 2 | < 0.1% | |
| 1500 | 2 | < 0.1% | |
| 450 | 2 | < 0.1% | |
| 1600 | 2 | < 0.1% | |
| 0 | 1 | < 0.1% | |
| 505 | 1 | < 0.1% | |
| Other values (15) | 15 | 0.2% | |
| (Missing) | 8671 | 99.6% |
| Value | Count | Frequency (%) | |
| 0 | 1 | < 0.1% | |
| 140 | 1 | < 0.1% | |
| 250 | 1 | < 0.1% | |
| 450 | 2 | < 0.1% | |
| 500 | 3 | < 0.1% |
| Value | Count | Frequency (%) | |
| 5300 | 1 | < 0.1% | |
| 4000 | 1 | < 0.1% | |
| 3000 | 1 | < 0.1% | |
| 2400 | 1 | < 0.1% | |
| 1700 | 1 | < 0.1% |
| Distinct count | 465 |
|---|---|
| Unique (%) | 5.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 68.0 KiB |
| $100.00 | 382 |
|---|---|
| $150.00 | 305 |
| $75.00 | 259 |
| $80.00 | 223 |
| $90.00 | 215 |
| Other values (460) |
| Value | Count | Frequency (%) | |
| $100.00 | 382 | 4.4% | |
| $150.00 | 305 | 3.5% | |
| $75.00 | 259 | 3.0% | |
| $80.00 | 223 | 2.6% | |
| $90.00 | 215 | 2.5% | |
| $125.00 | 214 | 2.5% | |
| $85.00 | 206 | 2.4% | |
| $50.00 | 190 | 2.2% | |
| $120.00 | 187 | 2.1% | |
| $99.00 | 185 | 2.1% | |
| Other values (455) | 6342 | 72.8% |
Length
| Max length | 10 |
|---|---|
| Median length | 7 |
| Mean length | 6.62529 |
| Min length | 5 |
| Distinct count | 254 |
|---|---|
| Unique (%) | 29.7% |
| Missing | 7854 |
| Missing (%) | 90.2% |
| Memory size | 68.0 KiB |
| $600.00 | 45 |
|---|---|
| $500.00 | 45 |
| $700.00 | 30 |
| $400.00 | 29 |
| $1,000.00 | 29 |
| Other values (249) |
| Value | Count | Frequency (%) | |
| $600.00 | 45 | 0.5% | |
| $500.00 | 45 | 0.5% | |
| $700.00 | 30 | 0.3% | |
| $400.00 | 29 | 0.3% | |
| $1,000.00 | 29 | 0.3% | |
| $750.00 | 27 | 0.3% | |
| $800.00 | 24 | 0.3% | |
| $900.00 | 24 | 0.3% | |
| $450.00 | 23 | 0.3% | |
| $650.00 | 19 | 0.2% | |
| Other values (244) | 559 | 6.4% | |
| (Missing) | 7854 | 90.2% |
Length
| Max length | 10 |
|---|---|
| Median length | 3 |
| Mean length | 3.43891 |
| Min length | 3 |
| Distinct count | 240 |
|---|---|
| Unique (%) | 32.6% |
| Missing | 7972 |
| Missing (%) | 91.5% |
| Memory size | 68.0 KiB |
| $1,500.00 | 25 |
|---|---|
| $3,000.00 | 25 |
| $2,500.00 | 23 |
| $3,500.00 | 20 |
| $1,800.00 | 19 |
| Other values (235) |
| Value | Count | Frequency (%) | |
| $1,500.00 | 25 | 0.3% | |
| $3,000.00 | 25 | 0.3% | |
| $2,500.00 | 23 | 0.3% | |
| $3,500.00 | 20 | 0.2% | |
| $1,800.00 | 19 | 0.2% | |
| $2,200.00 | 18 | 0.2% | |
| $4,000.00 | 16 | 0.2% | |
| $1,200.00 | 15 | 0.2% | |
| $2,800.00 | 14 | 0.2% | |
| $1,600.00 | 14 | 0.2% | |
| Other values (230) | 547 | 6.3% | |
| (Missing) | 7972 | 91.5% |
Length
| Max length | 10 |
|---|---|
| Median length | 3 |
| Mean length | 3.49633 |
| Min length | 3 |
| Distinct count | 92 |
|---|---|
| Unique (%) | 1.6% |
| Missing | 2845 |
| Missing (%) | 32.7% |
| Memory size | 68.0 KiB |
| $0.00 | |
|---|---|
| $500.00 | |
| $100.00 | |
| $250.00 | |
| $200.00 | |
| Other values (87) |
| Value | Count | Frequency (%) | |
| $0.00 | 2356 | 27.1% | |
| $500.00 | 767 | 8.8% | |
| $100.00 | 614 | 7.1% | |
| $250.00 | 413 | 4.7% | |
| $200.00 | 389 | 4.5% | |
| $150.00 | 294 | 3.4% | |
| $300.00 | 268 | 3.1% | |
| $1,000.00 | 188 | 2.2% | |
| $400.00 | 100 | 1.1% | |
| $1,500.00 | 65 | 0.7% | |
| Other values (82) | 409 | 4.7% | |
| (Missing) | 2845 | 32.7% |
Length
| Max length | 9 |
|---|---|
| Median length | 5 |
| Mean length | 5.22784 |
| Min length | 3 |
| Distinct count | 167 |
|---|---|
| Unique (%) | 2.4% |
| Missing | 1632 |
| Missing (%) | 18.7% |
| Memory size | 68.0 KiB |
| $50.00 | |
|---|---|
| $100.00 | 462 |
| $75.00 | 431 |
| $0.00 | 424 |
| $25.00 | 337 |
| Other values (162) |
| Value | Count | Frequency (%) | |
| $50.00 | 653 | 7.5% | |
| $100.00 | 462 | 5.3% | |
| $75.00 | 431 | 4.9% | |
| $0.00 | 424 | 4.9% | |
| $25.00 | 337 | 3.9% | |
| $20.00 | 330 | 3.8% | |
| $150.00 | 261 | 3.0% | |
| $30.00 | 247 | 2.8% | |
| $60.00 | 233 | 2.7% | |
| $80.00 | 233 | 2.7% | |
| Other values (157) | 3465 | 39.8% | |
| (Missing) | 1632 | 18.7% |
Length
| Max length | 7 |
|---|---|
| Median length | 6 |
| Mean length | 5.61656 |
| Min length | 3 |
guests_included
Real number (ℝ≥0)
| Distinct count | 15 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.78594 |
|---|---|
| Minimum | 1 |
| Maximum | 16 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 68.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 5 |
| Maximum | 16 |
| Range | 15 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.48098 |
|---|---|
| Coefficient of variation (CV) | 0.82924 |
| Kurtosis | 11.4306 |
| Mean | 1.78594 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.85966 |
| Sum | 15552 |
| Variance | 2.19329 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=15)
| Value | Count | Frequency (%) | |
| 1 | 5595 | 64.3% | |
| 2 | 1691 | 19.4% | |
| 4 | 712 | 8.2% | |
| 3 | 264 | 3.0% | |
| 6 | 194 | 2.2% | |
| 5 | 111 | 1.3% | |
| 8 | 62 | 0.7% | |
| 7 | 37 | 0.4% | |
| 10 | 25 | 0.3% | |
| 12 | 8 | 0.1% | |
| Other values (5) | 9 | 0.1% |
| Value | Count | Frequency (%) | |
| 1 | 5595 | 64.3% | |
| 2 | 1691 | 19.4% | |
| 3 | 264 | 3.0% | |
| 4 | 712 | 8.2% | |
| 5 | 111 | 1.3% |
| Value | Count | Frequency (%) | |
| 16 | 3 | < 0.1% | |
| 15 | 1 | < 0.1% | |
| 14 | 1 | < 0.1% | |
| 12 | 8 | 0.1% | |
| 11 | 1 | < 0.1% |
| Distinct count | 64 |
|---|---|
| Unique (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 68.0 KiB |
| $0.00 | |
|---|---|
| $10.00 | |
| $25.00 | |
| $20.00 | |
| $15.00 | |
| Other values (59) |
| Value | Count | Frequency (%) | |
| $0.00 | 4874 | 56.0% | |
| $10.00 | 674 | 7.7% | |
| $25.00 | 653 | 7.5% | |
| $20.00 | 602 | 6.9% | |
| $15.00 | 507 | 5.8% | |
| $50.00 | 317 | 3.6% | |
| $30.00 | 213 | 2.4% | |
| $35.00 | 148 | 1.7% | |
| $5.00 | 135 | 1.6% | |
| $40.00 | 102 | 1.2% | |
| Other values (54) | 483 | 5.5% |
Length
| Max length | 7 |
|---|---|
| Median length | 5 |
| Mean length | 5.43339 |
| Min length | 5 |
minimum_nights
Real number (ℝ≥0)
| Distinct count | 61 |
|---|---|
| Unique (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.42708 |
|---|---|
| Minimum | 1 |
| Maximum | 600 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 68.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 3 |
| 95-th percentile | 30 |
| Maximum | 600 |
| Range | 599 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 23.6425 |
|---|---|
| Coefficient of variation (CV) | 3.18328 |
| Kurtosis | 186.356 |
| Mean | 7.42708 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 11.3438 |
| Sum | 64675 |
| Variance | 558.966 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 2 | 2984 | 34.3% | |
| 1 | 2458 | 28.2% | |
| 3 | 1316 | 15.1% | |
| 30 | 656 | 7.5% | |
| 4 | 324 | 3.7% | |
| 5 | 223 | 2.6% | |
| 7 | 180 | 2.1% | |
| 14 | 79 | 0.9% | |
| 10 | 59 | 0.7% | |
| 6 | 58 | 0.7% | |
| Other values (51) | 371 | 4.3% |
| Value | Count | Frequency (%) | |
| 1 | 2458 | 28.2% | |
| 2 | 2984 | 34.3% | |
| 3 | 1316 | 15.1% | |
| 4 | 324 | 3.7% | |
| 5 | 223 | 2.6% |
| Value | Count | Frequency (%) | |
| 600 | 1 | < 0.1% | |
| 555 | 2 | < 0.1% | |
| 365 | 4 | < 0.1% | |
| 364 | 1 | < 0.1% | |
| 360 | 3 | < 0.1% |
| Distinct count | 151 |
|---|---|
| Unique (%) | 1.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 258741 |
|---|---|
| Minimum | 1 |
| Maximum | 2.14748e+09 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 68.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 30 |
| median | 1125 |
| Q3 | 1125 |
| 95-th percentile | 1125 |
| Maximum | 2.14748e+09 |
| Range | 2.14748e+09 |
| Interquartile range (IQR) | 1095 |
Descriptive statistics
| Standard deviation | 2.30377e+07 |
|---|---|
| Coefficient of variation (CV) | 89.0374 |
| Kurtosis | 8670.38 |
| Mean | 258741 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 93.0233 |
| Sum | 2.25312e+09 |
| Variance | 5.30734e+14 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 1125 | 4420 | 50.8% | |
| 30 | 486 | 5.6% | |
| 365 | 374 | 4.3% | |
| 7 | 319 | 3.7% | |
| 14 | 238 | 2.7% | |
| 90 | 234 | 2.7% | |
| 5 | 169 | 1.9% | |
| 60 | 160 | 1.8% | |
| 28 | 157 | 1.8% | |
| 3 | 156 | 1.8% | |
| Other values (141) | 1995 | 22.9% |
| Value | Count | Frequency (%) | |
| 1 | 7 | 0.1% | |
| 2 | 43 | 0.5% | |
| 3 | 156 | 1.8% | |
| 4 | 131 | 1.5% | |
| 5 | 169 | 1.9% |
| Value | Count | Frequency (%) | |
| 2.14748e+09 | 1 | < 0.1% | |
| 1e+08 | 1 | < 0.1% | |
| 99999 | 1 | < 0.1% | |
| 10000 | 2 | < 0.1% | |
| 3365 | 2 | < 0.1% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| id | name | neighbourhood | neighbourhood_cleansed | zipcode | property_type | room_type | accommodates | bathrooms | bedrooms | beds | amenities | square_feet | price | weekly_price | monthly_price | security_deposit | cleaning_fee | guests_included | extra_people | minimum_nights | maximum_nights | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 3663 | Classic Rowhouse: Porch+ART+Parking | Manor Park | Brightwood Park, Crestwood, Petworth | 20011 | Townhouse | Entire home/apt | 4 | 3.5 | 4.0 | 2.0 | {TV,"Cable TV",Internet,Wifi,"Air conditioning",Kitchen,"Free parking on premises","Free street parking",Heating,"Family/kid friendly",Washer,Dryer,"Smoke alarm","Carbon monoxide alarm","First aid kit","Fire extinguisher",Essentials,Shampoo,"24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop-friendly workspace","Self check-in",Lockbox,Bathtub,"Children’s books and toys","Pack ’n Play/travel crib","Children’s dinnerware","Hot water","Luggage dropoff allowed","Long term stays allowed"} | NaN | $154.00 | NaN | NaN | $0.00 | $50.00 | 4 | $0.00 | 3 | 30 |
| 1 | 3670 | Beautiful Sun-Lit U Street 1BR/1BA | U Street Corridor | Howard University, Le Droit Park, Cardozo/Shaw | 20009 | Townhouse | Private room | 2 | 1.0 | 1.0 | 1.0 | {Wifi,"Air conditioning","Pets live on this property",Dog(s),Heating,"Family/kid friendly","Smoke alarm","First aid kit","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer","translation missing: en.hosting_amenity_50","Hot water","Extra pillows and blankets","Host greets you"} | NaN | $75.00 | $600.00 | NaN | $500.00 | $25.00 | 1 | $0.00 | 2 | 30 |
| 2 | 3686 | Vita's Hideaway | Anacostia | Historic Anacostia | 20020 | House | Private room | 1 | 1.0 | 1.0 | 1.0 | {Internet,Wifi,Kitchen,"Free street parking","Indoor fireplace",Heating,"Family/kid friendly",Washer,Dryer,"Smoke alarm","Carbon monoxide alarm","First aid kit",Essentials,Shampoo,Hangers,"Hot water","Bed linens","Extra pillows and blankets",Microwave,"Coffee maker",Refrigerator,Dishwasher,"Dishes and silverware","Cooking basics",Oven,Stove,"Patio or balcony","Garden or backyard"} | NaN | $55.00 | $430.00 | $975.00 | $0.00 | $0.00 | 1 | $0.00 | 2 | 365 |
| 3 | 3771 | Mt. Pleasant | Mount Pleasant | Columbia Heights, Mt. Pleasant, Pleasant Plains, Park View | 20009 | Other | Private room | 2 | 1.0 | 1.0 | 1.0 | {"Cable TV","Air conditioning",Heating,"Smoke alarm","Carbon monoxide alarm","First aid kit","Safety card","Fire extinguisher"} | NaN | $88.00 | NaN | NaN | NaN | NaN | 1 | $0.00 | 1 | 1125 |
| 4 | 3943 | Historic Rowhouse Near Monuments | Eckington | Edgewood, Bloomingdale, Truxton Circle, Eckington | 20002 | Townhouse | Private room | 2 | 1.0 | 1.0 | 1.0 | {Internet,Wifi,"Air conditioning","Free parking on premises","Pets live on this property",Cat(s),Heating,Washer,Dryer,"Smoke alarm","First aid kit","Fire extinguisher",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop-friendly workspace","translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50","Self check-in",Keypad,"Hot water","Bed linens","Coffee maker"} | NaN | $80.00 | NaN | $1,800.00 | NaN | NaN | 1 | $15.00 | 27 | 1125 |
| 5 | 4197 | Bedroom in DC 2 blocks to Metro | Capitol Hill | Capitol Hill, Lincoln Park | 20003 | House | Private room | 2 | 1.5 | 1.0 | 1.0 | {TV,Wifi,"Air conditioning",Kitchen,"Pets live on this property","Free street parking","Indoor fireplace",Heating,Washer,Dryer,"Smoke alarm","Carbon monoxide alarm","First aid kit","Safety card","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Laptop-friendly workspace","translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50",Bathtub,"Fireplace guards","Hot water","Bed linens","Extra pillows and blankets",Microwave,"Coffee maker",Refrigerator,Dishwasher,"Dishes and silverware","Cooking basics",Oven,Stove,"Patio or balcony","Garden or backyard","Luggage dropoff allowed","Long term stays allowed","Host greets you","Shower gel","Baking sheet","Trash can"} | NaN | $83.00 | NaN | NaN | NaN | $35.00 | 1 | $0.00 | 28 | 365 |
| 6 | 4501 | DC Rowhouse | Shaw | Shaw, Logan Circle | 20001 | House | Private room | 2 | 1.5 | 2.0 | 2.0 | {TV,"Cable TV",Internet,Wifi,"Air conditioning",Kitchen,"Free parking on premises",Breakfast,Heating,Washer,Dryer,"Smoke alarm","Carbon monoxide alarm","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Laptop-friendly workspace","translation missing: en.hosting_amenity_49"} | NaN | $150.00 | NaN | NaN | $500.00 | $0.00 | 2 | $50.00 | 30 | 90 |
| 7 | 4967 | DC, Near Metro | Ivy City | Ivy City, Arboretum, Trinidad, Carver Langston | 20002 | House | Private room | 1 | 3.0 | 1.0 | 1.0 | {"Cable TV",Internet,Wifi,"Air conditioning",Kitchen,"Smoking allowed","Indoor fireplace",Heating,Washer,Dryer,"Smoke alarm","Carbon monoxide alarm","Fire extinguisher","Lock on bedroom door","translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50"} | NaN | $99.00 | $600.00 | $1,500.00 | NaN | NaN | 1 | $0.00 | 2 | 365 |
| 8 | 5589 | Cozy apt in Adams Morgan | Adams Morgan | Kalorama Heights, Adams Morgan, Lanier Heights | 20009 | Apartment | Entire home/apt | 3 | 1.0 | 1.0 | 1.0 | {TV,Internet,Wifi,"Air conditioning",Kitchen,"Paid parking off premises","Free street parking","Indoor fireplace","Buzzer/wireless intercom",Heating,"Family/kid friendly",Washer,Dryer,"Smoke alarm","First aid kit","Safety card","Fire extinguisher",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop-friendly workspace","Self check-in",Lockbox,"Private entrance",Bathtub,"Window guards","Room-darkening shades","Hot water","Bed linens","Extra pillows and blankets","Ethernet connection",Microwave,"Coffee maker",Refrigerator,Dishwasher,"Dishes and silverware","Cooking basics",Oven,Stove,"Luggage dropoff allowed"} | NaN | $118.00 | $650.00 | $2,500.00 | $100.00 | $15.00 | 1 | $10.00 | 3 | 13 |
| 9 | 7103 | Best of Washington - Great neighborhood, parking | Berkley | Spring Valley, Palisades, Wesley Heights, Foxhall Crescent, Foxhall Village, Georgetown Reservoir | 20007 | Guest suite | Entire home/apt | 2 | 1.0 | 1.0 | 2.0 | {TV,"Cable TV",Internet,Wifi,"Air conditioning",Kitchen,"Pets allowed","Free street parking",Heating,"Family/kid friendly",Washer,Dryer,"Smoke alarm","Carbon monoxide alarm","First aid kit","Safety card","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door","24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop-friendly workspace","Private living room","Private entrance","Hot water","Bed linens","Extra pillows and blankets",Microwave,"Coffee maker",Refrigerator,"Dishes and silverware","BBQ grill","Garden or backyard","Luggage dropoff allowed","Long term stays allowed","Cleaning before checkout","Host greets you","Shower gel","Trash can"} | NaN | $99.00 | $506.00 | $1,517.00 | $0.00 | $35.00 | 1 | $15.00 | 3 | 365 |
Last rows
| id | name | neighbourhood | neighbourhood_cleansed | zipcode | property_type | room_type | accommodates | bathrooms | bedrooms | beds | amenities | square_feet | price | weekly_price | monthly_price | security_deposit | cleaning_fee | guests_included | extra_people | minimum_nights | maximum_nights | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8698 | 43818019 | Vibrant apartment in the heart of DC | Logan Circle | Kalorama Heights, Adams Morgan, Lanier Heights | 20009 | Apartment | Entire home/apt | 5 | 1.0 | 2.0 | 2.0 | {TV,Wifi,"Air conditioning",Kitchen,Heating,Washer,Dryer,"Smoke alarm","First aid kit",Essentials,Hangers,"Hair dryer",Iron,"Laptop-friendly workspace"} | NaN | $119.00 | NaN | NaN | $0.00 | $150.00 | 1 | $0.00 | 15 | 45 |
| 8699 | 43818065 | Cozy ☆ Well-Located Brookland Condo ☆ Paid Parking | Logan Circle | Brookland, Brentwood, Langdon | 20017 | Condominium | Entire home/apt | 4 | 1.0 | 1.0 | 1.0 | {TV,Wifi,"Air conditioning","Free parking on premises",Heating,"Smoke alarm","Carbon monoxide alarm",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop-friendly workspace","Private entrance"} | NaN | $99.00 | NaN | NaN | $300.00 | $70.00 | 1 | $10.00 | 2 | 14 |
| 8700 | 43818698 | Cozy ☆ Brookland Condo ☆ Sleeps 6 ☆ Paid Parking | Logan Circle | Brookland, Brentwood, Langdon | 20017 | Condominium | Entire home/apt | 6 | 1.0 | 2.0 | 4.0 | {Wifi,"Air conditioning","Free parking on premises",Heating,"Smoke alarm","Carbon monoxide alarm",Essentials,Hangers,"Hair dryer",Iron,"Laptop-friendly workspace","Private entrance"} | NaN | $123.00 | NaN | NaN | $400.00 | $100.00 | 2 | $10.00 | 2 | 14 |
| 8701 | 43818983 | Cozy ☆ Capitol Hill 2 BR Condo ☆ On Penn Ave | Logan Circle | Capitol Hill, Lincoln Park | 20003 | Condominium | Entire home/apt | 5 | 1.0 | 2.0 | 3.0 | {TV,Wifi,"Air conditioning",Kitchen,Heating,"Smoke alarm","Carbon monoxide alarm",Essentials,Hangers,"Hair dryer",Iron,"Laptop-friendly workspace","Private entrance"} | NaN | $129.00 | NaN | NaN | $500.00 | $100.00 | 2 | $10.00 | 2 | 30 |
| 8702 | 43819475 | Visually stunning contemporary condo | Logan Circle | Cleveland Park, Woodley Park, Massachusetts Avenue Heights, Woodland-Normanstone Terrace | 20016 | Loft | Entire home/apt | 4 | 1.5 | 2.0 | 2.0 | {TV,Wifi,"Air conditioning",Kitchen,"Free parking on premises",Breakfast,Heating,Washer,Dryer,"Smoke alarm","Carbon monoxide alarm","First aid kit","Fire extinguisher",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop-friendly workspace","Private entrance"} | NaN | $500.00 | NaN | NaN | NaN | $100.00 | 2 | $100.00 | 1 | 1125 |
| 8703 | 43819661 | Sojourn on Constitution Avenue 1 Bedroom | Capitol Hill | Union Station, Stanton Park, Kingman Park | 20002 | House | Entire home/apt | 2 | 1.0 | 1.0 | 1.0 | {TV,Wifi,"Air conditioning",Kitchen,Heating,"Smoke alarm","Carbon monoxide alarm","First aid kit","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Laptop-friendly workspace","Self check-in",Keypad,"Private entrance"} | NaN | $225.00 | NaN | NaN | $0.00 | $100.00 | 1 | $0.00 | 3 | 1125 |
| 8704 | 43819954 | Sojourn on Constitution Sleeps 5 | Outdoor Space | Logan Circle | Capitol Hill, Lincoln Park | 20002 | House | Entire home/apt | 5 | 1.0 | 2.0 | 2.0 | {TV,Wifi,"Air conditioning",Kitchen,Heating,Washer,Dryer,"Smoke alarm","Carbon monoxide alarm","First aid kit","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Private entrance"} | NaN | $325.00 | NaN | NaN | $0.00 | $150.00 | 1 | $0.00 | 3 | 1125 |
| 8705 | 43834495 | 2~BD 2~BA LUXURY CITY CENTER DC PENTHOUSE | Downtown/Penn Quarter | Downtown, Chinatown, Penn Quarters, Mount Vernon Square, North Capitol Street | 20268 | Apartment | Entire home/apt | 6 | 2.0 | 2.0 | 2.0 | {TV,Wifi,"Air conditioning",Pool,Kitchen,"Free parking on premises",Gym,Elevator,Heating,"Suitable for events",Washer,Dryer,"Smoke alarm","First aid kit",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop-friendly workspace","Hot water"} | NaN | $99.00 | NaN | NaN | NaN | $120.00 | 1 | $0.00 | 1 | 365 |
| 8706 | 43834631 | Nice for a couple room | Capitol Hill | Union Station, Stanton Park, Kingman Park | 20002 | House | Private room | 2 | 1.5 | 1.0 | 2.0 | {"Air conditioning",Kitchen,"Free parking on premises","Pets allowed",Breakfast,"Indoor fireplace",Heating,Washer,Dryer,"Smoke alarm","Carbon monoxide alarm","First aid kit","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Private living room"} | NaN | $100.00 | NaN | NaN | NaN | NaN | 1 | $0.00 | 1 | 28 |
| 8707 | 43834997 | The Chic suite on 16th st NW 1BD~1BA | Columbia Heights | Kalorama Heights, Adams Morgan, Lanier Heights | 20009 | Apartment | Entire home/apt | 3 | 1.0 | 1.0 | 2.0 | {TV,Wifi,"Air conditioning",Kitchen,Gym,Heating,"Suitable for events",Washer,Dryer,"Smoke alarm","First aid kit",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop-friendly workspace","Hot water"} | NaN | $70.00 | NaN | NaN | NaN | $100.00 | 1 | $0.00 | 1 | 365 |